Data Management Tools

Navicat provides a number of powerful tools for working with the databases.

The following tools are available:

Import Wizard
Imports data from TXT, CSV, XML, DBF, MS Excel and ODBC.

Export Wizard
Exports data to TXT, CSV, DBF, XML and MS Excel.

Data Transfer
Transfers tables/views/procedures/functions/sequences/events between databases/schemas or plain text file.

Data Synchronization
Synchronizes data in different databases/schemas to be kept up-to-date so that each repository contains the same information.

Structure Synchronization
Compares the structure of two similar databases/schemas and produces a set of alter statements in MySQL, Oracle, PostgreSQL and SQL Server.

Backup/Restore
Allows you to backup/restore your databases/schemas for MySQL, PostgreSQL and SQLite.

Batch Job/Schedule
Allows you to schedule a batch job which being executed at a specified time and support e-mail notification service.

Console
Provides interactive text-based screen for user query input and result output from MySQL, Oracle, PostgreSQL, SQLite and SQL Server.

Dump SQL File
Dumps database/schema/table(s) to SQL file.

Execute SQL File
Executes SQL file.

Convert to SQLite 3
Converts a SQLite 2 file into a SQLite 3 file.

Print Structure
Prints database/schema/table structure.

Log Files
Keeps track on the actions (e.g. SQL statements being executed) have been performed in Navicat.